package com.javaer666.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.javaer666.entity.Course;
import com.javaer666.entity.Course1;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface Course1Mapper extends BaseMapper<Course1> {
    @Insert("insert into course1 values (11,'spring',1001,1),(12,'spring',1001,1),(13,'spring',1001,1),(14,'spring',1001,1),(15,'spring',1001,1);")
    void  insertBatch();

    @Select("select * from course1 where MOD(cid,2)=1")
    List<Course> queryQiCid();
}
